package com.lilosoft.business.cga.models;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class EgsProjectExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public EgsProjectExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andProjectIdIsNull() {
            addCriterion("PROJECT_ID is null");
            return (Criteria) this;
        }

        public Criteria andProjectIdIsNotNull() {
            addCriterion("PROJECT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andProjectIdEqualTo(String value) {
            addCriterion("PROJECT_ID =", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdNotEqualTo(String value) {
            addCriterion("PROJECT_ID <>", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdGreaterThan(String value) {
            addCriterion("PROJECT_ID >", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdGreaterThanOrEqualTo(String value) {
            addCriterion("PROJECT_ID >=", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdLessThan(String value) {
            addCriterion("PROJECT_ID <", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdLessThanOrEqualTo(String value) {
            addCriterion("PROJECT_ID <=", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdLike(String value) {
            addCriterion("PROJECT_ID like", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdNotLike(String value) {
            addCriterion("PROJECT_ID not like", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdIn(List<String> values) {
            addCriterion("PROJECT_ID in", values, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdNotIn(List<String> values) {
            addCriterion("PROJECT_ID not in", values, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdBetween(String value1, String value2) {
            addCriterion("PROJECT_ID between", value1, value2, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdNotBetween(String value1, String value2) {
            addCriterion("PROJECT_ID not between", value1, value2, "projectId");
            return (Criteria) this;
        }

        public Criteria andVersionIsNull() {
            addCriterion("VERSION is null");
            return (Criteria) this;
        }

        public Criteria andVersionIsNotNull() {
            addCriterion("VERSION is not null");
            return (Criteria) this;
        }

        public Criteria andVersionEqualTo(Integer value) {
            addCriterion("VERSION =", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotEqualTo(Integer value) {
            addCriterion("VERSION <>", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionGreaterThan(Integer value) {
            addCriterion("VERSION >", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionGreaterThanOrEqualTo(Integer value) {
            addCriterion("VERSION >=", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionLessThan(Integer value) {
            addCriterion("VERSION <", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionLessThanOrEqualTo(Integer value) {
            addCriterion("VERSION <=", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionIn(List<Integer> values) {
            addCriterion("VERSION in", values, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotIn(List<Integer> values) {
            addCriterion("VERSION not in", values, "version");
            return (Criteria) this;
        }

        public Criteria andVersionBetween(Integer value1, Integer value2) {
            addCriterion("VERSION between", value1, value2, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotBetween(Integer value1, Integer value2) {
            addCriterion("VERSION not between", value1, value2, "version");
            return (Criteria) this;
        }

        public Criteria andProjectItemNoIsNull() {
            addCriterion("PROJECT_ITEM_NO is null");
            return (Criteria) this;
        }

        public Criteria andProjectItemNoIsNotNull() {
            addCriterion("PROJECT_ITEM_NO is not null");
            return (Criteria) this;
        }

        public Criteria andProjectItemNoEqualTo(String value) {
            addCriterion("PROJECT_ITEM_NO =", value, "projectItemNo");
            return (Criteria) this;
        }

        public Criteria andProjectItemNoNotEqualTo(String value) {
            addCriterion("PROJECT_ITEM_NO <>", value, "projectItemNo");
            return (Criteria) this;
        }

        public Criteria andProjectItemNoGreaterThan(String value) {
            addCriterion("PROJECT_ITEM_NO >", value, "projectItemNo");
            return (Criteria) this;
        }

        public Criteria andProjectItemNoGreaterThanOrEqualTo(String value) {
            addCriterion("PROJECT_ITEM_NO >=", value, "projectItemNo");
            return (Criteria) this;
        }

        public Criteria andProjectItemNoLessThan(String value) {
            addCriterion("PROJECT_ITEM_NO <", value, "projectItemNo");
            return (Criteria) this;
        }

        public Criteria andProjectItemNoLessThanOrEqualTo(String value) {
            addCriterion("PROJECT_ITEM_NO <=", value, "projectItemNo");
            return (Criteria) this;
        }

        public Criteria andProjectItemNoLike(String value) {
            addCriterion("PROJECT_ITEM_NO like", value, "projectItemNo");
            return (Criteria) this;
        }

        public Criteria andProjectItemNoNotLike(String value) {
            addCriterion("PROJECT_ITEM_NO not like", value, "projectItemNo");
            return (Criteria) this;
        }

        public Criteria andProjectItemNoIn(List<String> values) {
            addCriterion("PROJECT_ITEM_NO in", values, "projectItemNo");
            return (Criteria) this;
        }

        public Criteria andProjectItemNoNotIn(List<String> values) {
            addCriterion("PROJECT_ITEM_NO not in", values, "projectItemNo");
            return (Criteria) this;
        }

        public Criteria andProjectItemNoBetween(String value1, String value2) {
            addCriterion("PROJECT_ITEM_NO between", value1, value2, "projectItemNo");
            return (Criteria) this;
        }

        public Criteria andProjectItemNoNotBetween(String value1, String value2) {
            addCriterion("PROJECT_ITEM_NO not between", value1, value2, "projectItemNo");
            return (Criteria) this;
        }

        public Criteria andItemSubNoIsNull() {
            addCriterion("ITEM_SUB_NO is null");
            return (Criteria) this;
        }

        public Criteria andItemSubNoIsNotNull() {
            addCriterion("ITEM_SUB_NO is not null");
            return (Criteria) this;
        }

        public Criteria andItemSubNoEqualTo(String value) {
            addCriterion("ITEM_SUB_NO =", value, "itemSubNo");
            return (Criteria) this;
        }

        public Criteria andItemSubNoNotEqualTo(String value) {
            addCriterion("ITEM_SUB_NO <>", value, "itemSubNo");
            return (Criteria) this;
        }

        public Criteria andItemSubNoGreaterThan(String value) {
            addCriterion("ITEM_SUB_NO >", value, "itemSubNo");
            return (Criteria) this;
        }

        public Criteria andItemSubNoGreaterThanOrEqualTo(String value) {
            addCriterion("ITEM_SUB_NO >=", value, "itemSubNo");
            return (Criteria) this;
        }

        public Criteria andItemSubNoLessThan(String value) {
            addCriterion("ITEM_SUB_NO <", value, "itemSubNo");
            return (Criteria) this;
        }

        public Criteria andItemSubNoLessThanOrEqualTo(String value) {
            addCriterion("ITEM_SUB_NO <=", value, "itemSubNo");
            return (Criteria) this;
        }

        public Criteria andItemSubNoLike(String value) {
            addCriterion("ITEM_SUB_NO like", value, "itemSubNo");
            return (Criteria) this;
        }

        public Criteria andItemSubNoNotLike(String value) {
            addCriterion("ITEM_SUB_NO not like", value, "itemSubNo");
            return (Criteria) this;
        }

        public Criteria andItemSubNoIn(List<String> values) {
            addCriterion("ITEM_SUB_NO in", values, "itemSubNo");
            return (Criteria) this;
        }

        public Criteria andItemSubNoNotIn(List<String> values) {
            addCriterion("ITEM_SUB_NO not in", values, "itemSubNo");
            return (Criteria) this;
        }

        public Criteria andItemSubNoBetween(String value1, String value2) {
            addCriterion("ITEM_SUB_NO between", value1, value2, "itemSubNo");
            return (Criteria) this;
        }

        public Criteria andItemSubNoNotBetween(String value1, String value2) {
            addCriterion("ITEM_SUB_NO not between", value1, value2, "itemSubNo");
            return (Criteria) this;
        }

        public Criteria andProjectNoIsNull() {
            addCriterion("PROJECT_NO is null");
            return (Criteria) this;
        }

        public Criteria andProjectNoIsNotNull() {
            addCriterion("PROJECT_NO is not null");
            return (Criteria) this;
        }

        public Criteria andProjectNoEqualTo(String value) {
            addCriterion("PROJECT_NO =", value, "projectNo");
            return (Criteria) this;
        }

        public Criteria andProjectNoNotEqualTo(String value) {
            addCriterion("PROJECT_NO <>", value, "projectNo");
            return (Criteria) this;
        }

        public Criteria andProjectNoGreaterThan(String value) {
            addCriterion("PROJECT_NO >", value, "projectNo");
            return (Criteria) this;
        }

        public Criteria andProjectNoGreaterThanOrEqualTo(String value) {
            addCriterion("PROJECT_NO >=", value, "projectNo");
            return (Criteria) this;
        }

        public Criteria andProjectNoLessThan(String value) {
            addCriterion("PROJECT_NO <", value, "projectNo");
            return (Criteria) this;
        }

        public Criteria andProjectNoLessThanOrEqualTo(String value) {
            addCriterion("PROJECT_NO <=", value, "projectNo");
            return (Criteria) this;
        }

        public Criteria andProjectNoLike(String value) {
            addCriterion("PROJECT_NO like", value, "projectNo");
            return (Criteria) this;
        }

        public Criteria andProjectNoNotLike(String value) {
            addCriterion("PROJECT_NO not like", value, "projectNo");
            return (Criteria) this;
        }

        public Criteria andProjectNoIn(List<String> values) {
            addCriterion("PROJECT_NO in", values, "projectNo");
            return (Criteria) this;
        }

        public Criteria andProjectNoNotIn(List<String> values) {
            addCriterion("PROJECT_NO not in", values, "projectNo");
            return (Criteria) this;
        }

        public Criteria andProjectNoBetween(String value1, String value2) {
            addCriterion("PROJECT_NO between", value1, value2, "projectNo");
            return (Criteria) this;
        }

        public Criteria andProjectNoNotBetween(String value1, String value2) {
            addCriterion("PROJECT_NO not between", value1, value2, "projectNo");
            return (Criteria) this;
        }

        public Criteria andProjectShowNoIsNull() {
            addCriterion("PROJECT_SHOW_NO is null");
            return (Criteria) this;
        }

        public Criteria andProjectShowNoIsNotNull() {
            addCriterion("PROJECT_SHOW_NO is not null");
            return (Criteria) this;
        }

        public Criteria andProjectShowNoEqualTo(String value) {
            addCriterion("PROJECT_SHOW_NO =", value, "projectShowNo");
            return (Criteria) this;
        }

        public Criteria andProjectShowNoNotEqualTo(String value) {
            addCriterion("PROJECT_SHOW_NO <>", value, "projectShowNo");
            return (Criteria) this;
        }

        public Criteria andProjectShowNoGreaterThan(String value) {
            addCriterion("PROJECT_SHOW_NO >", value, "projectShowNo");
            return (Criteria) this;
        }

        public Criteria andProjectShowNoGreaterThanOrEqualTo(String value) {
            addCriterion("PROJECT_SHOW_NO >=", value, "projectShowNo");
            return (Criteria) this;
        }

        public Criteria andProjectShowNoLessThan(String value) {
            addCriterion("PROJECT_SHOW_NO <", value, "projectShowNo");
            return (Criteria) this;
        }

        public Criteria andProjectShowNoLessThanOrEqualTo(String value) {
            addCriterion("PROJECT_SHOW_NO <=", value, "projectShowNo");
            return (Criteria) this;
        }

        public Criteria andProjectShowNoLike(String value) {
            addCriterion("PROJECT_SHOW_NO like", value, "projectShowNo");
            return (Criteria) this;
        }

        public Criteria andProjectShowNoNotLike(String value) {
            addCriterion("PROJECT_SHOW_NO not like", value, "projectShowNo");
            return (Criteria) this;
        }

        public Criteria andProjectShowNoIn(List<String> values) {
            addCriterion("PROJECT_SHOW_NO in", values, "projectShowNo");
            return (Criteria) this;
        }

        public Criteria andProjectShowNoNotIn(List<String> values) {
            addCriterion("PROJECT_SHOW_NO not in", values, "projectShowNo");
            return (Criteria) this;
        }

        public Criteria andProjectShowNoBetween(String value1, String value2) {
            addCriterion("PROJECT_SHOW_NO between", value1, value2, "projectShowNo");
            return (Criteria) this;
        }

        public Criteria andProjectShowNoNotBetween(String value1, String value2) {
            addCriterion("PROJECT_SHOW_NO not between", value1, value2, "projectShowNo");
            return (Criteria) this;
        }

        public Criteria andGridNoIsNull() {
            addCriterion("GRID_NO is null");
            return (Criteria) this;
        }

        public Criteria andGridNoIsNotNull() {
            addCriterion("GRID_NO is not null");
            return (Criteria) this;
        }

        public Criteria andGridNoEqualTo(String value) {
            addCriterion("GRID_NO =", value, "gridNo");
            return (Criteria) this;
        }

        public Criteria andGridNoNotEqualTo(String value) {
            addCriterion("GRID_NO <>", value, "gridNo");
            return (Criteria) this;
        }

        public Criteria andGridNoGreaterThan(String value) {
            addCriterion("GRID_NO >", value, "gridNo");
            return (Criteria) this;
        }

        public Criteria andGridNoGreaterThanOrEqualTo(String value) {
            addCriterion("GRID_NO >=", value, "gridNo");
            return (Criteria) this;
        }

        public Criteria andGridNoLessThan(String value) {
            addCriterion("GRID_NO <", value, "gridNo");
            return (Criteria) this;
        }

        public Criteria andGridNoLessThanOrEqualTo(String value) {
            addCriterion("GRID_NO <=", value, "gridNo");
            return (Criteria) this;
        }

        public Criteria andGridNoLike(String value) {
            addCriterion("GRID_NO like", value, "gridNo");
            return (Criteria) this;
        }

        public Criteria andGridNoNotLike(String value) {
            addCriterion("GRID_NO not like", value, "gridNo");
            return (Criteria) this;
        }

        public Criteria andGridNoIn(List<String> values) {
            addCriterion("GRID_NO in", values, "gridNo");
            return (Criteria) this;
        }

        public Criteria andGridNoNotIn(List<String> values) {
            addCriterion("GRID_NO not in", values, "gridNo");
            return (Criteria) this;
        }

        public Criteria andGridNoBetween(String value1, String value2) {
            addCriterion("GRID_NO between", value1, value2, "gridNo");
            return (Criteria) this;
        }

        public Criteria andGridNoNotBetween(String value1, String value2) {
            addCriterion("GRID_NO not between", value1, value2, "gridNo");
            return (Criteria) this;
        }

        public Criteria andProjectNameIsNull() {
            addCriterion("PROJECT_NAME is null");
            return (Criteria) this;
        }

        public Criteria andProjectNameIsNotNull() {
            addCriterion("PROJECT_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andProjectNameEqualTo(String value) {
            addCriterion("PROJECT_NAME =", value, "projectName");
            return (Criteria) this;
        }

        public Criteria andProjectNameNotEqualTo(String value) {
            addCriterion("PROJECT_NAME <>", value, "projectName");
            return (Criteria) this;
        }

        public Criteria andProjectNameGreaterThan(String value) {
            addCriterion("PROJECT_NAME >", value, "projectName");
            return (Criteria) this;
        }

        public Criteria andProjectNameGreaterThanOrEqualTo(String value) {
            addCriterion("PROJECT_NAME >=", value, "projectName");
            return (Criteria) this;
        }

        public Criteria andProjectNameLessThan(String value) {
            addCriterion("PROJECT_NAME <", value, "projectName");
            return (Criteria) this;
        }

        public Criteria andProjectNameLessThanOrEqualTo(String value) {
            addCriterion("PROJECT_NAME <=", value, "projectName");
            return (Criteria) this;
        }

        public Criteria andProjectNameLike(String value) {
            addCriterion("PROJECT_NAME like", value, "projectName");
            return (Criteria) this;
        }

        public Criteria andProjectNameNotLike(String value) {
            addCriterion("PROJECT_NAME not like", value, "projectName");
            return (Criteria) this;
        }

        public Criteria andProjectNameIn(List<String> values) {
            addCriterion("PROJECT_NAME in", values, "projectName");
            return (Criteria) this;
        }

        public Criteria andProjectNameNotIn(List<String> values) {
            addCriterion("PROJECT_NAME not in", values, "projectName");
            return (Criteria) this;
        }

        public Criteria andProjectNameBetween(String value1, String value2) {
            addCriterion("PROJECT_NAME between", value1, value2, "projectName");
            return (Criteria) this;
        }

        public Criteria andProjectNameNotBetween(String value1, String value2) {
            addCriterion("PROJECT_NAME not between", value1, value2, "projectName");
            return (Criteria) this;
        }

        public Criteria andProjectTypeIsNull() {
            addCriterion("PROJECT_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andProjectTypeIsNotNull() {
            addCriterion("PROJECT_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andProjectTypeEqualTo(String value) {
            addCriterion("PROJECT_TYPE =", value, "projectType");
            return (Criteria) this;
        }

        public Criteria andProjectTypeNotEqualTo(String value) {
            addCriterion("PROJECT_TYPE <>", value, "projectType");
            return (Criteria) this;
        }

        public Criteria andProjectTypeGreaterThan(String value) {
            addCriterion("PROJECT_TYPE >", value, "projectType");
            return (Criteria) this;
        }

        public Criteria andProjectTypeGreaterThanOrEqualTo(String value) {
            addCriterion("PROJECT_TYPE >=", value, "projectType");
            return (Criteria) this;
        }

        public Criteria andProjectTypeLessThan(String value) {
            addCriterion("PROJECT_TYPE <", value, "projectType");
            return (Criteria) this;
        }

        public Criteria andProjectTypeLessThanOrEqualTo(String value) {
            addCriterion("PROJECT_TYPE <=", value, "projectType");
            return (Criteria) this;
        }

        public Criteria andProjectTypeLike(String value) {
            addCriterion("PROJECT_TYPE like", value, "projectType");
            return (Criteria) this;
        }

        public Criteria andProjectTypeNotLike(String value) {
            addCriterion("PROJECT_TYPE not like", value, "projectType");
            return (Criteria) this;
        }

        public Criteria andProjectTypeIn(List<String> values) {
            addCriterion("PROJECT_TYPE in", values, "projectType");
            return (Criteria) this;
        }

        public Criteria andProjectTypeNotIn(List<String> values) {
            addCriterion("PROJECT_TYPE not in", values, "projectType");
            return (Criteria) this;
        }

        public Criteria andProjectTypeBetween(String value1, String value2) {
            addCriterion("PROJECT_TYPE between", value1, value2, "projectType");
            return (Criteria) this;
        }

        public Criteria andProjectTypeNotBetween(String value1, String value2) {
            addCriterion("PROJECT_TYPE not between", value1, value2, "projectType");
            return (Criteria) this;
        }

        public Criteria andCaseTypeIsNull() {
            addCriterion("CASE_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andCaseTypeIsNotNull() {
            addCriterion("CASE_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andCaseTypeEqualTo(String value) {
            addCriterion("CASE_TYPE =", value, "caseType");
            return (Criteria) this;
        }

        public Criteria andCaseTypeNotEqualTo(String value) {
            addCriterion("CASE_TYPE <>", value, "caseType");
            return (Criteria) this;
        }

        public Criteria andCaseTypeGreaterThan(String value) {
            addCriterion("CASE_TYPE >", value, "caseType");
            return (Criteria) this;
        }

        public Criteria andCaseTypeGreaterThanOrEqualTo(String value) {
            addCriterion("CASE_TYPE >=", value, "caseType");
            return (Criteria) this;
        }

        public Criteria andCaseTypeLessThan(String value) {
            addCriterion("CASE_TYPE <", value, "caseType");
            return (Criteria) this;
        }

        public Criteria andCaseTypeLessThanOrEqualTo(String value) {
            addCriterion("CASE_TYPE <=", value, "caseType");
            return (Criteria) this;
        }

        public Criteria andCaseTypeLike(String value) {
            addCriterion("CASE_TYPE like", value, "caseType");
            return (Criteria) this;
        }

        public Criteria andCaseTypeNotLike(String value) {
            addCriterion("CASE_TYPE not like", value, "caseType");
            return (Criteria) this;
        }

        public Criteria andCaseTypeIn(List<String> values) {
            addCriterion("CASE_TYPE in", values, "caseType");
            return (Criteria) this;
        }

        public Criteria andCaseTypeNotIn(List<String> values) {
            addCriterion("CASE_TYPE not in", values, "caseType");
            return (Criteria) this;
        }

        public Criteria andCaseTypeBetween(String value1, String value2) {
            addCriterion("CASE_TYPE between", value1, value2, "caseType");
            return (Criteria) this;
        }

        public Criteria andCaseTypeNotBetween(String value1, String value2) {
            addCriterion("CASE_TYPE not between", value1, value2, "caseType");
            return (Criteria) this;
        }

        public Criteria andDealTypeIsNull() {
            addCriterion("DEAL_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andDealTypeIsNotNull() {
            addCriterion("DEAL_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andDealTypeEqualTo(String value) {
            addCriterion("DEAL_TYPE =", value, "dealType");
            return (Criteria) this;
        }

        public Criteria andDealTypeNotEqualTo(String value) {
            addCriterion("DEAL_TYPE <>", value, "dealType");
            return (Criteria) this;
        }

        public Criteria andDealTypeGreaterThan(String value) {
            addCriterion("DEAL_TYPE >", value, "dealType");
            return (Criteria) this;
        }

        public Criteria andDealTypeGreaterThanOrEqualTo(String value) {
            addCriterion("DEAL_TYPE >=", value, "dealType");
            return (Criteria) this;
        }

        public Criteria andDealTypeLessThan(String value) {
            addCriterion("DEAL_TYPE <", value, "dealType");
            return (Criteria) this;
        }

        public Criteria andDealTypeLessThanOrEqualTo(String value) {
            addCriterion("DEAL_TYPE <=", value, "dealType");
            return (Criteria) this;
        }

        public Criteria andDealTypeLike(String value) {
            addCriterion("DEAL_TYPE like", value, "dealType");
            return (Criteria) this;
        }

        public Criteria andDealTypeNotLike(String value) {
            addCriterion("DEAL_TYPE not like", value, "dealType");
            return (Criteria) this;
        }

        public Criteria andDealTypeIn(List<String> values) {
            addCriterion("DEAL_TYPE in", values, "dealType");
            return (Criteria) this;
        }

        public Criteria andDealTypeNotIn(List<String> values) {
            addCriterion("DEAL_TYPE not in", values, "dealType");
            return (Criteria) this;
        }

        public Criteria andDealTypeBetween(String value1, String value2) {
            addCriterion("DEAL_TYPE between", value1, value2, "dealType");
            return (Criteria) this;
        }

        public Criteria andDealTypeNotBetween(String value1, String value2) {
            addCriterion("DEAL_TYPE not between", value1, value2, "dealType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeIsNull() {
            addCriterion("SERVICE_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andServiceTypeIsNotNull() {
            addCriterion("SERVICE_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andServiceTypeEqualTo(String value) {
            addCriterion("SERVICE_TYPE =", value, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeNotEqualTo(String value) {
            addCriterion("SERVICE_TYPE <>", value, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeGreaterThan(String value) {
            addCriterion("SERVICE_TYPE >", value, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeGreaterThanOrEqualTo(String value) {
            addCriterion("SERVICE_TYPE >=", value, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeLessThan(String value) {
            addCriterion("SERVICE_TYPE <", value, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeLessThanOrEqualTo(String value) {
            addCriterion("SERVICE_TYPE <=", value, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeLike(String value) {
            addCriterion("SERVICE_TYPE like", value, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeNotLike(String value) {
            addCriterion("SERVICE_TYPE not like", value, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeIn(List<String> values) {
            addCriterion("SERVICE_TYPE in", values, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeNotIn(List<String> values) {
            addCriterion("SERVICE_TYPE not in", values, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeBetween(String value1, String value2) {
            addCriterion("SERVICE_TYPE between", value1, value2, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeNotBetween(String value1, String value2) {
            addCriterion("SERVICE_TYPE not between", value1, value2, "serviceType");
            return (Criteria) this;
        }

        public Criteria andDeptIdIsNull() {
            addCriterion("DEPT_ID is null");
            return (Criteria) this;
        }

        public Criteria andDeptIdIsNotNull() {
            addCriterion("DEPT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andDeptIdEqualTo(String value) {
            addCriterion("DEPT_ID =", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdNotEqualTo(String value) {
            addCriterion("DEPT_ID <>", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdGreaterThan(String value) {
            addCriterion("DEPT_ID >", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdGreaterThanOrEqualTo(String value) {
            addCriterion("DEPT_ID >=", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdLessThan(String value) {
            addCriterion("DEPT_ID <", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdLessThanOrEqualTo(String value) {
            addCriterion("DEPT_ID <=", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdLike(String value) {
            addCriterion("DEPT_ID like", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdNotLike(String value) {
            addCriterion("DEPT_ID not like", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdIn(List<String> values) {
            addCriterion("DEPT_ID in", values, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdNotIn(List<String> values) {
            addCriterion("DEPT_ID not in", values, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdBetween(String value1, String value2) {
            addCriterion("DEPT_ID between", value1, value2, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdNotBetween(String value1, String value2) {
            addCriterion("DEPT_ID not between", value1, value2, "deptId");
            return (Criteria) this;
        }

        public Criteria andRecordTimeIsNull() {
            addCriterion("RECORD_TIME is null");
            return (Criteria) this;
        }

        public Criteria andRecordTimeIsNotNull() {
            addCriterion("RECORD_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andRecordTimeEqualTo(Date value) {
            addCriterion("RECORD_TIME =", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeNotEqualTo(Date value) {
            addCriterion("RECORD_TIME <>", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeGreaterThan(Date value) {
            addCriterion("RECORD_TIME >", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("RECORD_TIME >=", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeLessThan(Date value) {
            addCriterion("RECORD_TIME <", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeLessThanOrEqualTo(Date value) {
            addCriterion("RECORD_TIME <=", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeIn(List<Date> values) {
            addCriterion("RECORD_TIME in", values, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeNotIn(List<Date> values) {
            addCriterion("RECORD_TIME not in", values, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeBetween(Date value1, Date value2) {
            addCriterion("RECORD_TIME between", value1, value2, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeNotBetween(Date value1, Date value2) {
            addCriterion("RECORD_TIME not between", value1, value2, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("REMARK is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("REMARK is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("REMARK =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("REMARK <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("REMARK >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("REMARK >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("REMARK <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("REMARK <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("REMARK like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("REMARK not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("REMARK in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("REMARK not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("REMARK between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("REMARK not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andIsUseIsNull() {
            addCriterion("IS_USE is null");
            return (Criteria) this;
        }

        public Criteria andIsUseIsNotNull() {
            addCriterion("IS_USE is not null");
            return (Criteria) this;
        }

        public Criteria andIsUseEqualTo(String value) {
            addCriterion("IS_USE =", value, "isUse");
            return (Criteria) this;
        }

        public Criteria andIsUseNotEqualTo(String value) {
            addCriterion("IS_USE <>", value, "isUse");
            return (Criteria) this;
        }

        public Criteria andIsUseGreaterThan(String value) {
            addCriterion("IS_USE >", value, "isUse");
            return (Criteria) this;
        }

        public Criteria andIsUseGreaterThanOrEqualTo(String value) {
            addCriterion("IS_USE >=", value, "isUse");
            return (Criteria) this;
        }

        public Criteria andIsUseLessThan(String value) {
            addCriterion("IS_USE <", value, "isUse");
            return (Criteria) this;
        }

        public Criteria andIsUseLessThanOrEqualTo(String value) {
            addCriterion("IS_USE <=", value, "isUse");
            return (Criteria) this;
        }

        public Criteria andIsUseLike(String value) {
            addCriterion("IS_USE like", value, "isUse");
            return (Criteria) this;
        }

        public Criteria andIsUseNotLike(String value) {
            addCriterion("IS_USE not like", value, "isUse");
            return (Criteria) this;
        }

        public Criteria andIsUseIn(List<String> values) {
            addCriterion("IS_USE in", values, "isUse");
            return (Criteria) this;
        }

        public Criteria andIsUseNotIn(List<String> values) {
            addCriterion("IS_USE not in", values, "isUse");
            return (Criteria) this;
        }

        public Criteria andIsUseBetween(String value1, String value2) {
            addCriterion("IS_USE between", value1, value2, "isUse");
            return (Criteria) this;
        }

        public Criteria andIsUseNotBetween(String value1, String value2) {
            addCriterion("IS_USE not between", value1, value2, "isUse");
            return (Criteria) this;
        }

        public Criteria andIsPublicIsNull() {
            addCriterion("IS_PUBLIC is null");
            return (Criteria) this;
        }

        public Criteria andIsPublicIsNotNull() {
            addCriterion("IS_PUBLIC is not null");
            return (Criteria) this;
        }

        public Criteria andIsPublicEqualTo(String value) {
            addCriterion("IS_PUBLIC =", value, "isPublic");
            return (Criteria) this;
        }

        public Criteria andIsPublicNotEqualTo(String value) {
            addCriterion("IS_PUBLIC <>", value, "isPublic");
            return (Criteria) this;
        }

        public Criteria andIsPublicGreaterThan(String value) {
            addCriterion("IS_PUBLIC >", value, "isPublic");
            return (Criteria) this;
        }

        public Criteria andIsPublicGreaterThanOrEqualTo(String value) {
            addCriterion("IS_PUBLIC >=", value, "isPublic");
            return (Criteria) this;
        }

        public Criteria andIsPublicLessThan(String value) {
            addCriterion("IS_PUBLIC <", value, "isPublic");
            return (Criteria) this;
        }

        public Criteria andIsPublicLessThanOrEqualTo(String value) {
            addCriterion("IS_PUBLIC <=", value, "isPublic");
            return (Criteria) this;
        }

        public Criteria andIsPublicLike(String value) {
            addCriterion("IS_PUBLIC like", value, "isPublic");
            return (Criteria) this;
        }

        public Criteria andIsPublicNotLike(String value) {
            addCriterion("IS_PUBLIC not like", value, "isPublic");
            return (Criteria) this;
        }

        public Criteria andIsPublicIn(List<String> values) {
            addCriterion("IS_PUBLIC in", values, "isPublic");
            return (Criteria) this;
        }

        public Criteria andIsPublicNotIn(List<String> values) {
            addCriterion("IS_PUBLIC not in", values, "isPublic");
            return (Criteria) this;
        }

        public Criteria andIsPublicBetween(String value1, String value2) {
            addCriterion("IS_PUBLIC between", value1, value2, "isPublic");
            return (Criteria) this;
        }

        public Criteria andIsPublicNotBetween(String value1, String value2) {
            addCriterion("IS_PUBLIC not between", value1, value2, "isPublic");
            return (Criteria) this;
        }

        public Criteria andAcceptNumIsNull() {
            addCriterion("ACCEPT_NUM is null");
            return (Criteria) this;
        }

        public Criteria andAcceptNumIsNotNull() {
            addCriterion("ACCEPT_NUM is not null");
            return (Criteria) this;
        }

        public Criteria andAcceptNumEqualTo(Integer value) {
            addCriterion("ACCEPT_NUM =", value, "acceptNum");
            return (Criteria) this;
        }

        public Criteria andAcceptNumNotEqualTo(Integer value) {
            addCriterion("ACCEPT_NUM <>", value, "acceptNum");
            return (Criteria) this;
        }

        public Criteria andAcceptNumGreaterThan(Integer value) {
            addCriterion("ACCEPT_NUM >", value, "acceptNum");
            return (Criteria) this;
        }

        public Criteria andAcceptNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("ACCEPT_NUM >=", value, "acceptNum");
            return (Criteria) this;
        }

        public Criteria andAcceptNumLessThan(Integer value) {
            addCriterion("ACCEPT_NUM <", value, "acceptNum");
            return (Criteria) this;
        }

        public Criteria andAcceptNumLessThanOrEqualTo(Integer value) {
            addCriterion("ACCEPT_NUM <=", value, "acceptNum");
            return (Criteria) this;
        }

        public Criteria andAcceptNumIn(List<Integer> values) {
            addCriterion("ACCEPT_NUM in", values, "acceptNum");
            return (Criteria) this;
        }

        public Criteria andAcceptNumNotIn(List<Integer> values) {
            addCriterion("ACCEPT_NUM not in", values, "acceptNum");
            return (Criteria) this;
        }

        public Criteria andAcceptNumBetween(Integer value1, Integer value2) {
            addCriterion("ACCEPT_NUM between", value1, value2, "acceptNum");
            return (Criteria) this;
        }

        public Criteria andAcceptNumNotBetween(Integer value1, Integer value2) {
            addCriterion("ACCEPT_NUM not between", value1, value2, "acceptNum");
            return (Criteria) this;
        }

        public Criteria andAdvisoryNumIsNull() {
            addCriterion("ADVISORY_NUM is null");
            return (Criteria) this;
        }

        public Criteria andAdvisoryNumIsNotNull() {
            addCriterion("ADVISORY_NUM is not null");
            return (Criteria) this;
        }

        public Criteria andAdvisoryNumEqualTo(Integer value) {
            addCriterion("ADVISORY_NUM =", value, "advisoryNum");
            return (Criteria) this;
        }

        public Criteria andAdvisoryNumNotEqualTo(Integer value) {
            addCriterion("ADVISORY_NUM <>", value, "advisoryNum");
            return (Criteria) this;
        }

        public Criteria andAdvisoryNumGreaterThan(Integer value) {
            addCriterion("ADVISORY_NUM >", value, "advisoryNum");
            return (Criteria) this;
        }

        public Criteria andAdvisoryNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("ADVISORY_NUM >=", value, "advisoryNum");
            return (Criteria) this;
        }

        public Criteria andAdvisoryNumLessThan(Integer value) {
            addCriterion("ADVISORY_NUM <", value, "advisoryNum");
            return (Criteria) this;
        }

        public Criteria andAdvisoryNumLessThanOrEqualTo(Integer value) {
            addCriterion("ADVISORY_NUM <=", value, "advisoryNum");
            return (Criteria) this;
        }

        public Criteria andAdvisoryNumIn(List<Integer> values) {
            addCriterion("ADVISORY_NUM in", values, "advisoryNum");
            return (Criteria) this;
        }

        public Criteria andAdvisoryNumNotIn(List<Integer> values) {
            addCriterion("ADVISORY_NUM not in", values, "advisoryNum");
            return (Criteria) this;
        }

        public Criteria andAdvisoryNumBetween(Integer value1, Integer value2) {
            addCriterion("ADVISORY_NUM between", value1, value2, "advisoryNum");
            return (Criteria) this;
        }

        public Criteria andAdvisoryNumNotBetween(Integer value1, Integer value2) {
            addCriterion("ADVISORY_NUM not between", value1, value2, "advisoryNum");
            return (Criteria) this;
        }

        public Criteria andAreaCodeIdIsNull() {
            addCriterion("AREA_CODE_ID is null");
            return (Criteria) this;
        }

        public Criteria andAreaCodeIdIsNotNull() {
            addCriterion("AREA_CODE_ID is not null");
            return (Criteria) this;
        }

        public Criteria andAreaCodeIdEqualTo(String value) {
            addCriterion("AREA_CODE_ID =", value, "areaCodeId");
            return (Criteria) this;
        }

        public Criteria andAreaCodeIdNotEqualTo(String value) {
            addCriterion("AREA_CODE_ID <>", value, "areaCodeId");
            return (Criteria) this;
        }

        public Criteria andAreaCodeIdGreaterThan(String value) {
            addCriterion("AREA_CODE_ID >", value, "areaCodeId");
            return (Criteria) this;
        }

        public Criteria andAreaCodeIdGreaterThanOrEqualTo(String value) {
            addCriterion("AREA_CODE_ID >=", value, "areaCodeId");
            return (Criteria) this;
        }

        public Criteria andAreaCodeIdLessThan(String value) {
            addCriterion("AREA_CODE_ID <", value, "areaCodeId");
            return (Criteria) this;
        }

        public Criteria andAreaCodeIdLessThanOrEqualTo(String value) {
            addCriterion("AREA_CODE_ID <=", value, "areaCodeId");
            return (Criteria) this;
        }

        public Criteria andAreaCodeIdLike(String value) {
            addCriterion("AREA_CODE_ID like", value, "areaCodeId");
            return (Criteria) this;
        }

        public Criteria andAreaCodeIdNotLike(String value) {
            addCriterion("AREA_CODE_ID not like", value, "areaCodeId");
            return (Criteria) this;
        }

        public Criteria andAreaCodeIdIn(List<String> values) {
            addCriterion("AREA_CODE_ID in", values, "areaCodeId");
            return (Criteria) this;
        }

        public Criteria andAreaCodeIdNotIn(List<String> values) {
            addCriterion("AREA_CODE_ID not in", values, "areaCodeId");
            return (Criteria) this;
        }

        public Criteria andAreaCodeIdBetween(String value1, String value2) {
            addCriterion("AREA_CODE_ID between", value1, value2, "areaCodeId");
            return (Criteria) this;
        }

        public Criteria andAreaCodeIdNotBetween(String value1, String value2) {
            addCriterion("AREA_CODE_ID not between", value1, value2, "areaCodeId");
            return (Criteria) this;
        }

        public Criteria andFirstLetterIsNull() {
            addCriterion("FIRST_LETTER is null");
            return (Criteria) this;
        }

        public Criteria andFirstLetterIsNotNull() {
            addCriterion("FIRST_LETTER is not null");
            return (Criteria) this;
        }

        public Criteria andFirstLetterEqualTo(String value) {
            addCriterion("FIRST_LETTER =", value, "firstLetter");
            return (Criteria) this;
        }

        public Criteria andFirstLetterNotEqualTo(String value) {
            addCriterion("FIRST_LETTER <>", value, "firstLetter");
            return (Criteria) this;
        }

        public Criteria andFirstLetterGreaterThan(String value) {
            addCriterion("FIRST_LETTER >", value, "firstLetter");
            return (Criteria) this;
        }

        public Criteria andFirstLetterGreaterThanOrEqualTo(String value) {
            addCriterion("FIRST_LETTER >=", value, "firstLetter");
            return (Criteria) this;
        }

        public Criteria andFirstLetterLessThan(String value) {
            addCriterion("FIRST_LETTER <", value, "firstLetter");
            return (Criteria) this;
        }

        public Criteria andFirstLetterLessThanOrEqualTo(String value) {
            addCriterion("FIRST_LETTER <=", value, "firstLetter");
            return (Criteria) this;
        }

        public Criteria andFirstLetterLike(String value) {
            addCriterion("FIRST_LETTER like", value, "firstLetter");
            return (Criteria) this;
        }

        public Criteria andFirstLetterNotLike(String value) {
            addCriterion("FIRST_LETTER not like", value, "firstLetter");
            return (Criteria) this;
        }

        public Criteria andFirstLetterIn(List<String> values) {
            addCriterion("FIRST_LETTER in", values, "firstLetter");
            return (Criteria) this;
        }

        public Criteria andFirstLetterNotIn(List<String> values) {
            addCriterion("FIRST_LETTER not in", values, "firstLetter");
            return (Criteria) this;
        }

        public Criteria andFirstLetterBetween(String value1, String value2) {
            addCriterion("FIRST_LETTER between", value1, value2, "firstLetter");
            return (Criteria) this;
        }

        public Criteria andFirstLetterNotBetween(String value1, String value2) {
            addCriterion("FIRST_LETTER not between", value1, value2, "firstLetter");
            return (Criteria) this;
        }

        public Criteria andPublicUrlIsNull() {
            addCriterion("PUBLIC_URL is null");
            return (Criteria) this;
        }

        public Criteria andPublicUrlIsNotNull() {
            addCriterion("PUBLIC_URL is not null");
            return (Criteria) this;
        }

        public Criteria andPublicUrlEqualTo(String value) {
            addCriterion("PUBLIC_URL =", value, "publicUrl");
            return (Criteria) this;
        }

        public Criteria andPublicUrlNotEqualTo(String value) {
            addCriterion("PUBLIC_URL <>", value, "publicUrl");
            return (Criteria) this;
        }

        public Criteria andPublicUrlGreaterThan(String value) {
            addCriterion("PUBLIC_URL >", value, "publicUrl");
            return (Criteria) this;
        }

        public Criteria andPublicUrlGreaterThanOrEqualTo(String value) {
            addCriterion("PUBLIC_URL >=", value, "publicUrl");
            return (Criteria) this;
        }

        public Criteria andPublicUrlLessThan(String value) {
            addCriterion("PUBLIC_URL <", value, "publicUrl");
            return (Criteria) this;
        }

        public Criteria andPublicUrlLessThanOrEqualTo(String value) {
            addCriterion("PUBLIC_URL <=", value, "publicUrl");
            return (Criteria) this;
        }

        public Criteria andPublicUrlLike(String value) {
            addCriterion("PUBLIC_URL like", value, "publicUrl");
            return (Criteria) this;
        }

        public Criteria andPublicUrlNotLike(String value) {
            addCriterion("PUBLIC_URL not like", value, "publicUrl");
            return (Criteria) this;
        }

        public Criteria andPublicUrlIn(List<String> values) {
            addCriterion("PUBLIC_URL in", values, "publicUrl");
            return (Criteria) this;
        }

        public Criteria andPublicUrlNotIn(List<String> values) {
            addCriterion("PUBLIC_URL not in", values, "publicUrl");
            return (Criteria) this;
        }

        public Criteria andPublicUrlBetween(String value1, String value2) {
            addCriterion("PUBLIC_URL between", value1, value2, "publicUrl");
            return (Criteria) this;
        }

        public Criteria andPublicUrlNotBetween(String value1, String value2) {
            addCriterion("PUBLIC_URL not between", value1, value2, "publicUrl");
            return (Criteria) this;
        }

        public Criteria andDeptUrlIsNull() {
            addCriterion("DEPT_URL is null");
            return (Criteria) this;
        }

        public Criteria andDeptUrlIsNotNull() {
            addCriterion("DEPT_URL is not null");
            return (Criteria) this;
        }

        public Criteria andDeptUrlEqualTo(String value) {
            addCriterion("DEPT_URL =", value, "deptUrl");
            return (Criteria) this;
        }

        public Criteria andDeptUrlNotEqualTo(String value) {
            addCriterion("DEPT_URL <>", value, "deptUrl");
            return (Criteria) this;
        }

        public Criteria andDeptUrlGreaterThan(String value) {
            addCriterion("DEPT_URL >", value, "deptUrl");
            return (Criteria) this;
        }

        public Criteria andDeptUrlGreaterThanOrEqualTo(String value) {
            addCriterion("DEPT_URL >=", value, "deptUrl");
            return (Criteria) this;
        }

        public Criteria andDeptUrlLessThan(String value) {
            addCriterion("DEPT_URL <", value, "deptUrl");
            return (Criteria) this;
        }

        public Criteria andDeptUrlLessThanOrEqualTo(String value) {
            addCriterion("DEPT_URL <=", value, "deptUrl");
            return (Criteria) this;
        }

        public Criteria andDeptUrlLike(String value) {
            addCriterion("DEPT_URL like", value, "deptUrl");
            return (Criteria) this;
        }

        public Criteria andDeptUrlNotLike(String value) {
            addCriterion("DEPT_URL not like", value, "deptUrl");
            return (Criteria) this;
        }

        public Criteria andDeptUrlIn(List<String> values) {
            addCriterion("DEPT_URL in", values, "deptUrl");
            return (Criteria) this;
        }

        public Criteria andDeptUrlNotIn(List<String> values) {
            addCriterion("DEPT_URL not in", values, "deptUrl");
            return (Criteria) this;
        }

        public Criteria andDeptUrlBetween(String value1, String value2) {
            addCriterion("DEPT_URL between", value1, value2, "deptUrl");
            return (Criteria) this;
        }

        public Criteria andDeptUrlNotBetween(String value1, String value2) {
            addCriterion("DEPT_URL not between", value1, value2, "deptUrl");
            return (Criteria) this;
        }

        public Criteria andWorkFlowTypeIsNull() {
            addCriterion("WORK_FLOW_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andWorkFlowTypeIsNotNull() {
            addCriterion("WORK_FLOW_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andWorkFlowTypeEqualTo(String value) {
            addCriterion("WORK_FLOW_TYPE =", value, "workFlowType");
            return (Criteria) this;
        }

        public Criteria andWorkFlowTypeNotEqualTo(String value) {
            addCriterion("WORK_FLOW_TYPE <>", value, "workFlowType");
            return (Criteria) this;
        }

        public Criteria andWorkFlowTypeGreaterThan(String value) {
            addCriterion("WORK_FLOW_TYPE >", value, "workFlowType");
            return (Criteria) this;
        }

        public Criteria andWorkFlowTypeGreaterThanOrEqualTo(String value) {
            addCriterion("WORK_FLOW_TYPE >=", value, "workFlowType");
            return (Criteria) this;
        }

        public Criteria andWorkFlowTypeLessThan(String value) {
            addCriterion("WORK_FLOW_TYPE <", value, "workFlowType");
            return (Criteria) this;
        }

        public Criteria andWorkFlowTypeLessThanOrEqualTo(String value) {
            addCriterion("WORK_FLOW_TYPE <=", value, "workFlowType");
            return (Criteria) this;
        }

        public Criteria andWorkFlowTypeLike(String value) {
            addCriterion("WORK_FLOW_TYPE like", value, "workFlowType");
            return (Criteria) this;
        }

        public Criteria andWorkFlowTypeNotLike(String value) {
            addCriterion("WORK_FLOW_TYPE not like", value, "workFlowType");
            return (Criteria) this;
        }

        public Criteria andWorkFlowTypeIn(List<String> values) {
            addCriterion("WORK_FLOW_TYPE in", values, "workFlowType");
            return (Criteria) this;
        }

        public Criteria andWorkFlowTypeNotIn(List<String> values) {
            addCriterion("WORK_FLOW_TYPE not in", values, "workFlowType");
            return (Criteria) this;
        }

        public Criteria andWorkFlowTypeBetween(String value1, String value2) {
            addCriterion("WORK_FLOW_TYPE between", value1, value2, "workFlowType");
            return (Criteria) this;
        }

        public Criteria andWorkFlowTypeNotBetween(String value1, String value2) {
            addCriterion("WORK_FLOW_TYPE not between", value1, value2, "workFlowType");
            return (Criteria) this;
        }

        public Criteria andStateIsNull() {
            addCriterion("STATE is null");
            return (Criteria) this;
        }

        public Criteria andStateIsNotNull() {
            addCriterion("STATE is not null");
            return (Criteria) this;
        }

        public Criteria andStateEqualTo(String value) {
            addCriterion("STATE =", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotEqualTo(String value) {
            addCriterion("STATE <>", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThan(String value) {
            addCriterion("STATE >", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThanOrEqualTo(String value) {
            addCriterion("STATE >=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThan(String value) {
            addCriterion("STATE <", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThanOrEqualTo(String value) {
            addCriterion("STATE <=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLike(String value) {
            addCriterion("STATE like", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotLike(String value) {
            addCriterion("STATE not like", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateIn(List<String> values) {
            addCriterion("STATE in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotIn(List<String> values) {
            addCriterion("STATE not in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateBetween(String value1, String value2) {
            addCriterion("STATE between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotBetween(String value1, String value2) {
            addCriterion("STATE not between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andApprovalIsNull() {
            addCriterion("APPROVAL is null");
            return (Criteria) this;
        }

        public Criteria andApprovalIsNotNull() {
            addCriterion("APPROVAL is not null");
            return (Criteria) this;
        }

        public Criteria andApprovalEqualTo(String value) {
            addCriterion("APPROVAL =", value, "approval");
            return (Criteria) this;
        }

        public Criteria andApprovalNotEqualTo(String value) {
            addCriterion("APPROVAL <>", value, "approval");
            return (Criteria) this;
        }

        public Criteria andApprovalGreaterThan(String value) {
            addCriterion("APPROVAL >", value, "approval");
            return (Criteria) this;
        }

        public Criteria andApprovalGreaterThanOrEqualTo(String value) {
            addCriterion("APPROVAL >=", value, "approval");
            return (Criteria) this;
        }

        public Criteria andApprovalLessThan(String value) {
            addCriterion("APPROVAL <", value, "approval");
            return (Criteria) this;
        }

        public Criteria andApprovalLessThanOrEqualTo(String value) {
            addCriterion("APPROVAL <=", value, "approval");
            return (Criteria) this;
        }

        public Criteria andApprovalLike(String value) {
            addCriterion("APPROVAL like", value, "approval");
            return (Criteria) this;
        }

        public Criteria andApprovalNotLike(String value) {
            addCriterion("APPROVAL not like", value, "approval");
            return (Criteria) this;
        }

        public Criteria andApprovalIn(List<String> values) {
            addCriterion("APPROVAL in", values, "approval");
            return (Criteria) this;
        }

        public Criteria andApprovalNotIn(List<String> values) {
            addCriterion("APPROVAL not in", values, "approval");
            return (Criteria) this;
        }

        public Criteria andApprovalBetween(String value1, String value2) {
            addCriterion("APPROVAL between", value1, value2, "approval");
            return (Criteria) this;
        }

        public Criteria andApprovalNotBetween(String value1, String value2) {
            addCriterion("APPROVAL not between", value1, value2, "approval");
            return (Criteria) this;
        }

        public Criteria andConfidentialIsNull() {
            addCriterion("CONFIDENTIAL is null");
            return (Criteria) this;
        }

        public Criteria andConfidentialIsNotNull() {
            addCriterion("CONFIDENTIAL is not null");
            return (Criteria) this;
        }

        public Criteria andConfidentialEqualTo(String value) {
            addCriterion("CONFIDENTIAL =", value, "confidential");
            return (Criteria) this;
        }

        public Criteria andConfidentialNotEqualTo(String value) {
            addCriterion("CONFIDENTIAL <>", value, "confidential");
            return (Criteria) this;
        }

        public Criteria andConfidentialGreaterThan(String value) {
            addCriterion("CONFIDENTIAL >", value, "confidential");
            return (Criteria) this;
        }

        public Criteria andConfidentialGreaterThanOrEqualTo(String value) {
            addCriterion("CONFIDENTIAL >=", value, "confidential");
            return (Criteria) this;
        }

        public Criteria andConfidentialLessThan(String value) {
            addCriterion("CONFIDENTIAL <", value, "confidential");
            return (Criteria) this;
        }

        public Criteria andConfidentialLessThanOrEqualTo(String value) {
            addCriterion("CONFIDENTIAL <=", value, "confidential");
            return (Criteria) this;
        }

        public Criteria andConfidentialLike(String value) {
            addCriterion("CONFIDENTIAL like", value, "confidential");
            return (Criteria) this;
        }

        public Criteria andConfidentialNotLike(String value) {
            addCriterion("CONFIDENTIAL not like", value, "confidential");
            return (Criteria) this;
        }

        public Criteria andConfidentialIn(List<String> values) {
            addCriterion("CONFIDENTIAL in", values, "confidential");
            return (Criteria) this;
        }

        public Criteria andConfidentialNotIn(List<String> values) {
            addCriterion("CONFIDENTIAL not in", values, "confidential");
            return (Criteria) this;
        }

        public Criteria andConfidentialBetween(String value1, String value2) {
            addCriterion("CONFIDENTIAL between", value1, value2, "confidential");
            return (Criteria) this;
        }

        public Criteria andConfidentialNotBetween(String value1, String value2) {
            addCriterion("CONFIDENTIAL not between", value1, value2, "confidential");
            return (Criteria) this;
        }

        public Criteria andAcceptingRangeIsNull() {
            addCriterion("ACCEPTING_RANGE is null");
            return (Criteria) this;
        }

        public Criteria andAcceptingRangeIsNotNull() {
            addCriterion("ACCEPTING_RANGE is not null");
            return (Criteria) this;
        }

        public Criteria andAcceptingRangeEqualTo(String value) {
            addCriterion("ACCEPTING_RANGE =", value, "acceptingRange");
            return (Criteria) this;
        }

        public Criteria andAcceptingRangeNotEqualTo(String value) {
            addCriterion("ACCEPTING_RANGE <>", value, "acceptingRange");
            return (Criteria) this;
        }

        public Criteria andAcceptingRangeGreaterThan(String value) {
            addCriterion("ACCEPTING_RANGE >", value, "acceptingRange");
            return (Criteria) this;
        }

        public Criteria andAcceptingRangeGreaterThanOrEqualTo(String value) {
            addCriterion("ACCEPTING_RANGE >=", value, "acceptingRange");
            return (Criteria) this;
        }

        public Criteria andAcceptingRangeLessThan(String value) {
            addCriterion("ACCEPTING_RANGE <", value, "acceptingRange");
            return (Criteria) this;
        }

        public Criteria andAcceptingRangeLessThanOrEqualTo(String value) {
            addCriterion("ACCEPTING_RANGE <=", value, "acceptingRange");
            return (Criteria) this;
        }

        public Criteria andAcceptingRangeLike(String value) {
            addCriterion("ACCEPTING_RANGE like", value, "acceptingRange");
            return (Criteria) this;
        }

        public Criteria andAcceptingRangeNotLike(String value) {
            addCriterion("ACCEPTING_RANGE not like", value, "acceptingRange");
            return (Criteria) this;
        }

        public Criteria andAcceptingRangeIn(List<String> values) {
            addCriterion("ACCEPTING_RANGE in", values, "acceptingRange");
            return (Criteria) this;
        }

        public Criteria andAcceptingRangeNotIn(List<String> values) {
            addCriterion("ACCEPTING_RANGE not in", values, "acceptingRange");
            return (Criteria) this;
        }

        public Criteria andAcceptingRangeBetween(String value1, String value2) {
            addCriterion("ACCEPTING_RANGE between", value1, value2, "acceptingRange");
            return (Criteria) this;
        }

        public Criteria andAcceptingRangeNotBetween(String value1, String value2) {
            addCriterion("ACCEPTING_RANGE not between", value1, value2, "acceptingRange");
            return (Criteria) this;
        }

        public Criteria andDistributeSysTypeIsNull() {
            addCriterion("DISTRIBUTE_SYS_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andDistributeSysTypeIsNotNull() {
            addCriterion("DISTRIBUTE_SYS_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andDistributeSysTypeEqualTo(String value) {
            addCriterion("DISTRIBUTE_SYS_TYPE =", value, "distributeSysType");
            return (Criteria) this;
        }

        public Criteria andDistributeSysTypeNotEqualTo(String value) {
            addCriterion("DISTRIBUTE_SYS_TYPE <>", value, "distributeSysType");
            return (Criteria) this;
        }

        public Criteria andDistributeSysTypeGreaterThan(String value) {
            addCriterion("DISTRIBUTE_SYS_TYPE >", value, "distributeSysType");
            return (Criteria) this;
        }

        public Criteria andDistributeSysTypeGreaterThanOrEqualTo(String value) {
            addCriterion("DISTRIBUTE_SYS_TYPE >=", value, "distributeSysType");
            return (Criteria) this;
        }

        public Criteria andDistributeSysTypeLessThan(String value) {
            addCriterion("DISTRIBUTE_SYS_TYPE <", value, "distributeSysType");
            return (Criteria) this;
        }

        public Criteria andDistributeSysTypeLessThanOrEqualTo(String value) {
            addCriterion("DISTRIBUTE_SYS_TYPE <=", value, "distributeSysType");
            return (Criteria) this;
        }

        public Criteria andDistributeSysTypeLike(String value) {
            addCriterion("DISTRIBUTE_SYS_TYPE like", value, "distributeSysType");
            return (Criteria) this;
        }

        public Criteria andDistributeSysTypeNotLike(String value) {
            addCriterion("DISTRIBUTE_SYS_TYPE not like", value, "distributeSysType");
            return (Criteria) this;
        }

        public Criteria andDistributeSysTypeIn(List<String> values) {
            addCriterion("DISTRIBUTE_SYS_TYPE in", values, "distributeSysType");
            return (Criteria) this;
        }

        public Criteria andDistributeSysTypeNotIn(List<String> values) {
            addCriterion("DISTRIBUTE_SYS_TYPE not in", values, "distributeSysType");
            return (Criteria) this;
        }

        public Criteria andDistributeSysTypeBetween(String value1, String value2) {
            addCriterion("DISTRIBUTE_SYS_TYPE between", value1, value2, "distributeSysType");
            return (Criteria) this;
        }

        public Criteria andDistributeSysTypeNotBetween(String value1, String value2) {
            addCriterion("DISTRIBUTE_SYS_TYPE not between", value1, value2, "distributeSysType");
            return (Criteria) this;
        }

        public Criteria andDistributeSysUrlIsNull() {
            addCriterion("DISTRIBUTE_SYS_URL is null");
            return (Criteria) this;
        }

        public Criteria andDistributeSysUrlIsNotNull() {
            addCriterion("DISTRIBUTE_SYS_URL is not null");
            return (Criteria) this;
        }

        public Criteria andDistributeSysUrlEqualTo(String value) {
            addCriterion("DISTRIBUTE_SYS_URL =", value, "distributeSysUrl");
            return (Criteria) this;
        }

        public Criteria andDistributeSysUrlNotEqualTo(String value) {
            addCriterion("DISTRIBUTE_SYS_URL <>", value, "distributeSysUrl");
            return (Criteria) this;
        }

        public Criteria andDistributeSysUrlGreaterThan(String value) {
            addCriterion("DISTRIBUTE_SYS_URL >", value, "distributeSysUrl");
            return (Criteria) this;
        }

        public Criteria andDistributeSysUrlGreaterThanOrEqualTo(String value) {
            addCriterion("DISTRIBUTE_SYS_URL >=", value, "distributeSysUrl");
            return (Criteria) this;
        }

        public Criteria andDistributeSysUrlLessThan(String value) {
            addCriterion("DISTRIBUTE_SYS_URL <", value, "distributeSysUrl");
            return (Criteria) this;
        }

        public Criteria andDistributeSysUrlLessThanOrEqualTo(String value) {
            addCriterion("DISTRIBUTE_SYS_URL <=", value, "distributeSysUrl");
            return (Criteria) this;
        }

        public Criteria andDistributeSysUrlLike(String value) {
            addCriterion("DISTRIBUTE_SYS_URL like", value, "distributeSysUrl");
            return (Criteria) this;
        }

        public Criteria andDistributeSysUrlNotLike(String value) {
            addCriterion("DISTRIBUTE_SYS_URL not like", value, "distributeSysUrl");
            return (Criteria) this;
        }

        public Criteria andDistributeSysUrlIn(List<String> values) {
            addCriterion("DISTRIBUTE_SYS_URL in", values, "distributeSysUrl");
            return (Criteria) this;
        }

        public Criteria andDistributeSysUrlNotIn(List<String> values) {
            addCriterion("DISTRIBUTE_SYS_URL not in", values, "distributeSysUrl");
            return (Criteria) this;
        }

        public Criteria andDistributeSysUrlBetween(String value1, String value2) {
            addCriterion("DISTRIBUTE_SYS_URL between", value1, value2, "distributeSysUrl");
            return (Criteria) this;
        }

        public Criteria andDistributeSysUrlNotBetween(String value1, String value2) {
            addCriterion("DISTRIBUTE_SYS_URL not between", value1, value2, "distributeSysUrl");
            return (Criteria) this;
        }

        public Criteria andTongbanRangeIsNull() {
            addCriterion("TONGBAN_RANGE is null");
            return (Criteria) this;
        }

        public Criteria andTongbanRangeIsNotNull() {
            addCriterion("TONGBAN_RANGE is not null");
            return (Criteria) this;
        }

        public Criteria andTongbanRangeEqualTo(String value) {
            addCriterion("TONGBAN_RANGE =", value, "tongbanRange");
            return (Criteria) this;
        }

        public Criteria andTongbanRangeNotEqualTo(String value) {
            addCriterion("TONGBAN_RANGE <>", value, "tongbanRange");
            return (Criteria) this;
        }

        public Criteria andTongbanRangeGreaterThan(String value) {
            addCriterion("TONGBAN_RANGE >", value, "tongbanRange");
            return (Criteria) this;
        }

        public Criteria andTongbanRangeGreaterThanOrEqualTo(String value) {
            addCriterion("TONGBAN_RANGE >=", value, "tongbanRange");
            return (Criteria) this;
        }

        public Criteria andTongbanRangeLessThan(String value) {
            addCriterion("TONGBAN_RANGE <", value, "tongbanRange");
            return (Criteria) this;
        }

        public Criteria andTongbanRangeLessThanOrEqualTo(String value) {
            addCriterion("TONGBAN_RANGE <=", value, "tongbanRange");
            return (Criteria) this;
        }

        public Criteria andTongbanRangeLike(String value) {
            addCriterion("TONGBAN_RANGE like", value, "tongbanRange");
            return (Criteria) this;
        }

        public Criteria andTongbanRangeNotLike(String value) {
            addCriterion("TONGBAN_RANGE not like", value, "tongbanRange");
            return (Criteria) this;
        }

        public Criteria andTongbanRangeIn(List<String> values) {
            addCriterion("TONGBAN_RANGE in", values, "tongbanRange");
            return (Criteria) this;
        }

        public Criteria andTongbanRangeNotIn(List<String> values) {
            addCriterion("TONGBAN_RANGE not in", values, "tongbanRange");
            return (Criteria) this;
        }

        public Criteria andTongbanRangeBetween(String value1, String value2) {
            addCriterion("TONGBAN_RANGE between", value1, value2, "tongbanRange");
            return (Criteria) this;
        }

        public Criteria andTongbanRangeNotBetween(String value1, String value2) {
            addCriterion("TONGBAN_RANGE not between", value1, value2, "tongbanRange");
            return (Criteria) this;
        }

        public Criteria andRunSystemTypeIsNull() {
            addCriterion("RUN_SYSTEM_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andRunSystemTypeIsNotNull() {
            addCriterion("RUN_SYSTEM_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andRunSystemTypeEqualTo(String value) {
            addCriterion("RUN_SYSTEM_TYPE =", value, "runSystemType");
            return (Criteria) this;
        }

        public Criteria andRunSystemTypeNotEqualTo(String value) {
            addCriterion("RUN_SYSTEM_TYPE <>", value, "runSystemType");
            return (Criteria) this;
        }

        public Criteria andRunSystemTypeGreaterThan(String value) {
            addCriterion("RUN_SYSTEM_TYPE >", value, "runSystemType");
            return (Criteria) this;
        }

        public Criteria andRunSystemTypeGreaterThanOrEqualTo(String value) {
            addCriterion("RUN_SYSTEM_TYPE >=", value, "runSystemType");
            return (Criteria) this;
        }

        public Criteria andRunSystemTypeLessThan(String value) {
            addCriterion("RUN_SYSTEM_TYPE <", value, "runSystemType");
            return (Criteria) this;
        }

        public Criteria andRunSystemTypeLessThanOrEqualTo(String value) {
            addCriterion("RUN_SYSTEM_TYPE <=", value, "runSystemType");
            return (Criteria) this;
        }

        public Criteria andRunSystemTypeLike(String value) {
            addCriterion("RUN_SYSTEM_TYPE like", value, "runSystemType");
            return (Criteria) this;
        }

        public Criteria andRunSystemTypeNotLike(String value) {
            addCriterion("RUN_SYSTEM_TYPE not like", value, "runSystemType");
            return (Criteria) this;
        }

        public Criteria andRunSystemTypeIn(List<String> values) {
            addCriterion("RUN_SYSTEM_TYPE in", values, "runSystemType");
            return (Criteria) this;
        }

        public Criteria andRunSystemTypeNotIn(List<String> values) {
            addCriterion("RUN_SYSTEM_TYPE not in", values, "runSystemType");
            return (Criteria) this;
        }

        public Criteria andRunSystemTypeBetween(String value1, String value2) {
            addCriterion("RUN_SYSTEM_TYPE between", value1, value2, "runSystemType");
            return (Criteria) this;
        }

        public Criteria andRunSystemTypeNotBetween(String value1, String value2) {
            addCriterion("RUN_SYSTEM_TYPE not between", value1, value2, "runSystemType");
            return (Criteria) this;
        }

        public Criteria andPowerUpdateTypeIsNull() {
            addCriterion("POWER_UPDATE_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andPowerUpdateTypeIsNotNull() {
            addCriterion("POWER_UPDATE_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andPowerUpdateTypeEqualTo(String value) {
            addCriterion("POWER_UPDATE_TYPE =", value, "powerUpdateType");
            return (Criteria) this;
        }

        public Criteria andPowerUpdateTypeNotEqualTo(String value) {
            addCriterion("POWER_UPDATE_TYPE <>", value, "powerUpdateType");
            return (Criteria) this;
        }

        public Criteria andPowerUpdateTypeGreaterThan(String value) {
            addCriterion("POWER_UPDATE_TYPE >", value, "powerUpdateType");
            return (Criteria) this;
        }

        public Criteria andPowerUpdateTypeGreaterThanOrEqualTo(String value) {
            addCriterion("POWER_UPDATE_TYPE >=", value, "powerUpdateType");
            return (Criteria) this;
        }

        public Criteria andPowerUpdateTypeLessThan(String value) {
            addCriterion("POWER_UPDATE_TYPE <", value, "powerUpdateType");
            return (Criteria) this;
        }

        public Criteria andPowerUpdateTypeLessThanOrEqualTo(String value) {
            addCriterion("POWER_UPDATE_TYPE <=", value, "powerUpdateType");
            return (Criteria) this;
        }

        public Criteria andPowerUpdateTypeLike(String value) {
            addCriterion("POWER_UPDATE_TYPE like", value, "powerUpdateType");
            return (Criteria) this;
        }

        public Criteria andPowerUpdateTypeNotLike(String value) {
            addCriterion("POWER_UPDATE_TYPE not like", value, "powerUpdateType");
            return (Criteria) this;
        }

        public Criteria andPowerUpdateTypeIn(List<String> values) {
            addCriterion("POWER_UPDATE_TYPE in", values, "powerUpdateType");
            return (Criteria) this;
        }

        public Criteria andPowerUpdateTypeNotIn(List<String> values) {
            addCriterion("POWER_UPDATE_TYPE not in", values, "powerUpdateType");
            return (Criteria) this;
        }

        public Criteria andPowerUpdateTypeBetween(String value1, String value2) {
            addCriterion("POWER_UPDATE_TYPE between", value1, value2, "powerUpdateType");
            return (Criteria) this;
        }

        public Criteria andPowerUpdateTypeNotBetween(String value1, String value2) {
            addCriterion("POWER_UPDATE_TYPE not between", value1, value2, "powerUpdateType");
            return (Criteria) this;
        }

        public Criteria andPowerStateIsNull() {
            addCriterion("POWER_STATE is null");
            return (Criteria) this;
        }

        public Criteria andPowerStateIsNotNull() {
            addCriterion("POWER_STATE is not null");
            return (Criteria) this;
        }

        public Criteria andPowerStateEqualTo(String value) {
            addCriterion("POWER_STATE =", value, "powerState");
            return (Criteria) this;
        }

        public Criteria andPowerStateNotEqualTo(String value) {
            addCriterion("POWER_STATE <>", value, "powerState");
            return (Criteria) this;
        }

        public Criteria andPowerStateGreaterThan(String value) {
            addCriterion("POWER_STATE >", value, "powerState");
            return (Criteria) this;
        }

        public Criteria andPowerStateGreaterThanOrEqualTo(String value) {
            addCriterion("POWER_STATE >=", value, "powerState");
            return (Criteria) this;
        }

        public Criteria andPowerStateLessThan(String value) {
            addCriterion("POWER_STATE <", value, "powerState");
            return (Criteria) this;
        }

        public Criteria andPowerStateLessThanOrEqualTo(String value) {
            addCriterion("POWER_STATE <=", value, "powerState");
            return (Criteria) this;
        }

        public Criteria andPowerStateLike(String value) {
            addCriterion("POWER_STATE like", value, "powerState");
            return (Criteria) this;
        }

        public Criteria andPowerStateNotLike(String value) {
            addCriterion("POWER_STATE not like", value, "powerState");
            return (Criteria) this;
        }

        public Criteria andPowerStateIn(List<String> values) {
            addCriterion("POWER_STATE in", values, "powerState");
            return (Criteria) this;
        }

        public Criteria andPowerStateNotIn(List<String> values) {
            addCriterion("POWER_STATE not in", values, "powerState");
            return (Criteria) this;
        }

        public Criteria andPowerStateBetween(String value1, String value2) {
            addCriterion("POWER_STATE between", value1, value2, "powerState");
            return (Criteria) this;
        }

        public Criteria andPowerStateNotBetween(String value1, String value2) {
            addCriterion("POWER_STATE not between", value1, value2, "powerState");
            return (Criteria) this;
        }

        public Criteria andImplemetSubjectNatureIsNull() {
            addCriterion("IMPLEMET_SUBJECT_NATURE is null");
            return (Criteria) this;
        }

        public Criteria andImplemetSubjectNatureIsNotNull() {
            addCriterion("IMPLEMET_SUBJECT_NATURE is not null");
            return (Criteria) this;
        }

        public Criteria andImplemetSubjectNatureEqualTo(String value) {
            addCriterion("IMPLEMET_SUBJECT_NATURE =", value, "implemetSubjectNature");
            return (Criteria) this;
        }

        public Criteria andImplemetSubjectNatureNotEqualTo(String value) {
            addCriterion("IMPLEMET_SUBJECT_NATURE <>", value, "implemetSubjectNature");
            return (Criteria) this;
        }

        public Criteria andImplemetSubjectNatureGreaterThan(String value) {
            addCriterion("IMPLEMET_SUBJECT_NATURE >", value, "implemetSubjectNature");
            return (Criteria) this;
        }

        public Criteria andImplemetSubjectNatureGreaterThanOrEqualTo(String value) {
            addCriterion("IMPLEMET_SUBJECT_NATURE >=", value, "implemetSubjectNature");
            return (Criteria) this;
        }

        public Criteria andImplemetSubjectNatureLessThan(String value) {
            addCriterion("IMPLEMET_SUBJECT_NATURE <", value, "implemetSubjectNature");
            return (Criteria) this;
        }

        public Criteria andImplemetSubjectNatureLessThanOrEqualTo(String value) {
            addCriterion("IMPLEMET_SUBJECT_NATURE <=", value, "implemetSubjectNature");
            return (Criteria) this;
        }

        public Criteria andImplemetSubjectNatureLike(String value) {
            addCriterion("IMPLEMET_SUBJECT_NATURE like", value, "implemetSubjectNature");
            return (Criteria) this;
        }

        public Criteria andImplemetSubjectNatureNotLike(String value) {
            addCriterion("IMPLEMET_SUBJECT_NATURE not like", value, "implemetSubjectNature");
            return (Criteria) this;
        }

        public Criteria andImplemetSubjectNatureIn(List<String> values) {
            addCriterion("IMPLEMET_SUBJECT_NATURE in", values, "implemetSubjectNature");
            return (Criteria) this;
        }

        public Criteria andImplemetSubjectNatureNotIn(List<String> values) {
            addCriterion("IMPLEMET_SUBJECT_NATURE not in", values, "implemetSubjectNature");
            return (Criteria) this;
        }

        public Criteria andImplemetSubjectNatureBetween(String value1, String value2) {
            addCriterion("IMPLEMET_SUBJECT_NATURE between", value1, value2, "implemetSubjectNature");
            return (Criteria) this;
        }

        public Criteria andImplemetSubjectNatureNotBetween(String value1, String value2) {
            addCriterion("IMPLEMET_SUBJECT_NATURE not between", value1, value2, "implemetSubjectNature");
            return (Criteria) this;
        }

        public Criteria andAuthorityDivisionIsNull() {
            addCriterion("AUTHORITY_DIVISION is null");
            return (Criteria) this;
        }

        public Criteria andAuthorityDivisionIsNotNull() {
            addCriterion("AUTHORITY_DIVISION is not null");
            return (Criteria) this;
        }

        public Criteria andAuthorityDivisionEqualTo(String value) {
            addCriterion("AUTHORITY_DIVISION =", value, "authorityDivision");
            return (Criteria) this;
        }

        public Criteria andAuthorityDivisionNotEqualTo(String value) {
            addCriterion("AUTHORITY_DIVISION <>", value, "authorityDivision");
            return (Criteria) this;
        }

        public Criteria andAuthorityDivisionGreaterThan(String value) {
            addCriterion("AUTHORITY_DIVISION >", value, "authorityDivision");
            return (Criteria) this;
        }

        public Criteria andAuthorityDivisionGreaterThanOrEqualTo(String value) {
            addCriterion("AUTHORITY_DIVISION >=", value, "authorityDivision");
            return (Criteria) this;
        }

        public Criteria andAuthorityDivisionLessThan(String value) {
            addCriterion("AUTHORITY_DIVISION <", value, "authorityDivision");
            return (Criteria) this;
        }

        public Criteria andAuthorityDivisionLessThanOrEqualTo(String value) {
            addCriterion("AUTHORITY_DIVISION <=", value, "authorityDivision");
            return (Criteria) this;
        }

        public Criteria andAuthorityDivisionLike(String value) {
            addCriterion("AUTHORITY_DIVISION like", value, "authorityDivision");
            return (Criteria) this;
        }

        public Criteria andAuthorityDivisionNotLike(String value) {
            addCriterion("AUTHORITY_DIVISION not like", value, "authorityDivision");
            return (Criteria) this;
        }

        public Criteria andAuthorityDivisionIn(List<String> values) {
            addCriterion("AUTHORITY_DIVISION in", values, "authorityDivision");
            return (Criteria) this;
        }

        public Criteria andAuthorityDivisionNotIn(List<String> values) {
            addCriterion("AUTHORITY_DIVISION not in", values, "authorityDivision");
            return (Criteria) this;
        }

        public Criteria andAuthorityDivisionBetween(String value1, String value2) {
            addCriterion("AUTHORITY_DIVISION between", value1, value2, "authorityDivision");
            return (Criteria) this;
        }

        public Criteria andAuthorityDivisionNotBetween(String value1, String value2) {
            addCriterion("AUTHORITY_DIVISION not between", value1, value2, "authorityDivision");
            return (Criteria) this;
        }

        public Criteria andStreetDealAuthorityIsNull() {
            addCriterion("STREET_DEAL_AUTHORITY is null");
            return (Criteria) this;
        }

        public Criteria andStreetDealAuthorityIsNotNull() {
            addCriterion("STREET_DEAL_AUTHORITY is not null");
            return (Criteria) this;
        }

        public Criteria andStreetDealAuthorityEqualTo(String value) {
            addCriterion("STREET_DEAL_AUTHORITY =", value, "streetDealAuthority");
            return (Criteria) this;
        }

        public Criteria andStreetDealAuthorityNotEqualTo(String value) {
            addCriterion("STREET_DEAL_AUTHORITY <>", value, "streetDealAuthority");
            return (Criteria) this;
        }

        public Criteria andStreetDealAuthorityGreaterThan(String value) {
            addCriterion("STREET_DEAL_AUTHORITY >", value, "streetDealAuthority");
            return (Criteria) this;
        }

        public Criteria andStreetDealAuthorityGreaterThanOrEqualTo(String value) {
            addCriterion("STREET_DEAL_AUTHORITY >=", value, "streetDealAuthority");
            return (Criteria) this;
        }

        public Criteria andStreetDealAuthorityLessThan(String value) {
            addCriterion("STREET_DEAL_AUTHORITY <", value, "streetDealAuthority");
            return (Criteria) this;
        }

        public Criteria andStreetDealAuthorityLessThanOrEqualTo(String value) {
            addCriterion("STREET_DEAL_AUTHORITY <=", value, "streetDealAuthority");
            return (Criteria) this;
        }

        public Criteria andStreetDealAuthorityLike(String value) {
            addCriterion("STREET_DEAL_AUTHORITY like", value, "streetDealAuthority");
            return (Criteria) this;
        }

        public Criteria andStreetDealAuthorityNotLike(String value) {
            addCriterion("STREET_DEAL_AUTHORITY not like", value, "streetDealAuthority");
            return (Criteria) this;
        }

        public Criteria andStreetDealAuthorityIn(List<String> values) {
            addCriterion("STREET_DEAL_AUTHORITY in", values, "streetDealAuthority");
            return (Criteria) this;
        }

        public Criteria andStreetDealAuthorityNotIn(List<String> values) {
            addCriterion("STREET_DEAL_AUTHORITY not in", values, "streetDealAuthority");
            return (Criteria) this;
        }

        public Criteria andStreetDealAuthorityBetween(String value1, String value2) {
            addCriterion("STREET_DEAL_AUTHORITY between", value1, value2, "streetDealAuthority");
            return (Criteria) this;
        }

        public Criteria andStreetDealAuthorityNotBetween(String value1, String value2) {
            addCriterion("STREET_DEAL_AUTHORITY not between", value1, value2, "streetDealAuthority");
            return (Criteria) this;
        }

        public Criteria andIsSyncIsNull() {
            addCriterion("IS_SYNC is null");
            return (Criteria) this;
        }

        public Criteria andIsSyncIsNotNull() {
            addCriterion("IS_SYNC is not null");
            return (Criteria) this;
        }

        public Criteria andIsSyncEqualTo(String value) {
            addCriterion("IS_SYNC =", value, "isSync");
            return (Criteria) this;
        }

        public Criteria andIsSyncNotEqualTo(String value) {
            addCriterion("IS_SYNC <>", value, "isSync");
            return (Criteria) this;
        }

        public Criteria andIsSyncGreaterThan(String value) {
            addCriterion("IS_SYNC >", value, "isSync");
            return (Criteria) this;
        }

        public Criteria andIsSyncGreaterThanOrEqualTo(String value) {
            addCriterion("IS_SYNC >=", value, "isSync");
            return (Criteria) this;
        }

        public Criteria andIsSyncLessThan(String value) {
            addCriterion("IS_SYNC <", value, "isSync");
            return (Criteria) this;
        }

        public Criteria andIsSyncLessThanOrEqualTo(String value) {
            addCriterion("IS_SYNC <=", value, "isSync");
            return (Criteria) this;
        }

        public Criteria andIsSyncLike(String value) {
            addCriterion("IS_SYNC like", value, "isSync");
            return (Criteria) this;
        }

        public Criteria andIsSyncNotLike(String value) {
            addCriterion("IS_SYNC not like", value, "isSync");
            return (Criteria) this;
        }

        public Criteria andIsSyncIn(List<String> values) {
            addCriterion("IS_SYNC in", values, "isSync");
            return (Criteria) this;
        }

        public Criteria andIsSyncNotIn(List<String> values) {
            addCriterion("IS_SYNC not in", values, "isSync");
            return (Criteria) this;
        }

        public Criteria andIsSyncBetween(String value1, String value2) {
            addCriterion("IS_SYNC between", value1, value2, "isSync");
            return (Criteria) this;
        }

        public Criteria andIsSyncNotBetween(String value1, String value2) {
            addCriterion("IS_SYNC not between", value1, value2, "isSync");
            return (Criteria) this;
        }

        public Criteria andYsTypeIsNull() {
            addCriterion("YS_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andYsTypeIsNotNull() {
            addCriterion("YS_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andYsTypeEqualTo(String value) {
            addCriterion("YS_TYPE =", value, "ysType");
            return (Criteria) this;
        }

        public Criteria andYsTypeNotEqualTo(String value) {
            addCriterion("YS_TYPE <>", value, "ysType");
            return (Criteria) this;
        }

        public Criteria andYsTypeGreaterThan(String value) {
            addCriterion("YS_TYPE >", value, "ysType");
            return (Criteria) this;
        }

        public Criteria andYsTypeGreaterThanOrEqualTo(String value) {
            addCriterion("YS_TYPE >=", value, "ysType");
            return (Criteria) this;
        }

        public Criteria andYsTypeLessThan(String value) {
            addCriterion("YS_TYPE <", value, "ysType");
            return (Criteria) this;
        }

        public Criteria andYsTypeLessThanOrEqualTo(String value) {
            addCriterion("YS_TYPE <=", value, "ysType");
            return (Criteria) this;
        }

        public Criteria andYsTypeLike(String value) {
            addCriterion("YS_TYPE like", value, "ysType");
            return (Criteria) this;
        }

        public Criteria andYsTypeNotLike(String value) {
            addCriterion("YS_TYPE not like", value, "ysType");
            return (Criteria) this;
        }

        public Criteria andYsTypeIn(List<String> values) {
            addCriterion("YS_TYPE in", values, "ysType");
            return (Criteria) this;
        }

        public Criteria andYsTypeNotIn(List<String> values) {
            addCriterion("YS_TYPE not in", values, "ysType");
            return (Criteria) this;
        }

        public Criteria andYsTypeBetween(String value1, String value2) {
            addCriterion("YS_TYPE between", value1, value2, "ysType");
            return (Criteria) this;
        }

        public Criteria andYsTypeNotBetween(String value1, String value2) {
            addCriterion("YS_TYPE not between", value1, value2, "ysType");
            return (Criteria) this;
        }

        public Criteria andYsFsIsNull() {
            addCriterion("YS_FS is null");
            return (Criteria) this;
        }

        public Criteria andYsFsIsNotNull() {
            addCriterion("YS_FS is not null");
            return (Criteria) this;
        }

        public Criteria andYsFsEqualTo(String value) {
            addCriterion("YS_FS =", value, "ysFs");
            return (Criteria) this;
        }

        public Criteria andYsFsNotEqualTo(String value) {
            addCriterion("YS_FS <>", value, "ysFs");
            return (Criteria) this;
        }

        public Criteria andYsFsGreaterThan(String value) {
            addCriterion("YS_FS >", value, "ysFs");
            return (Criteria) this;
        }

        public Criteria andYsFsGreaterThanOrEqualTo(String value) {
            addCriterion("YS_FS >=", value, "ysFs");
            return (Criteria) this;
        }

        public Criteria andYsFsLessThan(String value) {
            addCriterion("YS_FS <", value, "ysFs");
            return (Criteria) this;
        }

        public Criteria andYsFsLessThanOrEqualTo(String value) {
            addCriterion("YS_FS <=", value, "ysFs");
            return (Criteria) this;
        }

        public Criteria andYsFsLike(String value) {
            addCriterion("YS_FS like", value, "ysFs");
            return (Criteria) this;
        }

        public Criteria andYsFsNotLike(String value) {
            addCriterion("YS_FS not like", value, "ysFs");
            return (Criteria) this;
        }

        public Criteria andYsFsIn(List<String> values) {
            addCriterion("YS_FS in", values, "ysFs");
            return (Criteria) this;
        }

        public Criteria andYsFsNotIn(List<String> values) {
            addCriterion("YS_FS not in", values, "ysFs");
            return (Criteria) this;
        }

        public Criteria andYsFsBetween(String value1, String value2) {
            addCriterion("YS_FS between", value1, value2, "ysFs");
            return (Criteria) this;
        }

        public Criteria andYsFsNotBetween(String value1, String value2) {
            addCriterion("YS_FS not between", value1, value2, "ysFs");
            return (Criteria) this;
        }

        public Criteria andSyncItemIdIsNull() {
            addCriterion("SYNC_ITEM_ID is null");
            return (Criteria) this;
        }

        public Criteria andSyncItemIdIsNotNull() {
            addCriterion("SYNC_ITEM_ID is not null");
            return (Criteria) this;
        }

        public Criteria andSyncItemIdEqualTo(String value) {
            addCriterion("SYNC_ITEM_ID =", value, "syncItemId");
            return (Criteria) this;
        }

        public Criteria andSyncItemIdNotEqualTo(String value) {
            addCriterion("SYNC_ITEM_ID <>", value, "syncItemId");
            return (Criteria) this;
        }

        public Criteria andSyncItemIdGreaterThan(String value) {
            addCriterion("SYNC_ITEM_ID >", value, "syncItemId");
            return (Criteria) this;
        }

        public Criteria andSyncItemIdGreaterThanOrEqualTo(String value) {
            addCriterion("SYNC_ITEM_ID >=", value, "syncItemId");
            return (Criteria) this;
        }

        public Criteria andSyncItemIdLessThan(String value) {
            addCriterion("SYNC_ITEM_ID <", value, "syncItemId");
            return (Criteria) this;
        }

        public Criteria andSyncItemIdLessThanOrEqualTo(String value) {
            addCriterion("SYNC_ITEM_ID <=", value, "syncItemId");
            return (Criteria) this;
        }

        public Criteria andSyncItemIdLike(String value) {
            addCriterion("SYNC_ITEM_ID like", value, "syncItemId");
            return (Criteria) this;
        }

        public Criteria andSyncItemIdNotLike(String value) {
            addCriterion("SYNC_ITEM_ID not like", value, "syncItemId");
            return (Criteria) this;
        }

        public Criteria andSyncItemIdIn(List<String> values) {
            addCriterion("SYNC_ITEM_ID in", values, "syncItemId");
            return (Criteria) this;
        }

        public Criteria andSyncItemIdNotIn(List<String> values) {
            addCriterion("SYNC_ITEM_ID not in", values, "syncItemId");
            return (Criteria) this;
        }

        public Criteria andSyncItemIdBetween(String value1, String value2) {
            addCriterion("SYNC_ITEM_ID between", value1, value2, "syncItemId");
            return (Criteria) this;
        }

        public Criteria andSyncItemIdNotBetween(String value1, String value2) {
            addCriterion("SYNC_ITEM_ID not between", value1, value2, "syncItemId");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}